Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# BASEDIM

The BASEDIM function loops over a concat dimension and returns the name of the dimension from which the current value of a concat dimension comes.

Return Value

`TEXT`

Syntax

BASEDIM(concatdim [LEAF])

Arguments

concatdim

  Specifies the concat dimension for which you want the names of the base or component dimensions. The data type of the values returned is TEXT.

LEAF

  The LEAF keyword causes BASEDIM to return the names of the component dimensions of the concatdim dimension. The base dimensions of a concat dimension are the simple, conjoint, or other concat dimensions that you specify with the basedimlist argument when you define the concat. Simple dimensions and conjoint dimensions are the bottom-level components, or leaves, of a concat dimension.

  When you specify a concat dimension as a base dimension when defining a concat, then the base dimensions of that inner concat are component dimensions of the outer concat. Using the LEAF keyword results in BASEDIM returning the names of the component simple and conjoint dimensions of the inner concat dimension.

  When the base dimensions are all simple dimensions or conjoint dimensions, then the base dimensions are the bottom-level components and therefore BASEDIM returns the names of those dimensions whether or not you use the LEAF keyword.

When the base dimensions are all simple dimensions or conjoint dimensions, then the base dimensions are the bottom-level components and therefore BASEDIM returns the names of those dimensions whether or not you use the LEAF keyword.

Examples

Example 8-26 Returning Base Dimension Names

In this example the `product` dimension is limited to two values, the `district` dimension is limited to its first three values and the `region` dimension has only three values. The example defines a nonunique concat dimension with `region` and `district` as its base dimensions and then defines another nonunique concat dimension with `product` and the first concat dimension as its base dimensions. The example then gets the names of the base dimensions of the outer concat.

    LIMIT district TO 'Boston' TO 'Chicago'
    LIMIT product TO 'Tents''Canoes'
    DEFINE region.district DIMENSION CONCAT(region district)
    DEFINE product.region.district DIMENSION CONCAT(product region.district)
    REPORT BASEDIM(product.district.region)

The preceding statements return the following.

    PRODUCT
    PRODUCT
    REGION.DISTRICT
    REGION.DISTRICT
    REGION.DISTRICT
    REGION.DISTRICT
    REGION.DISTRICT
    REGION.DISTRICT

Example 8-27 Returning Component Dimension Names

This example uses the same objects as the previous example. It gets the names of the component dimensions of the concat dimension.

    REPORT BASEDIM(product.region.district LEAF)

The preceding statement returns the following.

    PRODUCT
    PRODUCT
    REGION
    REGION
    REGION
    DISTRICT
    DISTRICT
    DISTRICT